Export of Mail Ballot Status Data

Note:  This export is available only to counties using the Generic Envelope Reader Interface.

To run:  Vote By Mail > Envelope Reader Utilities > Export of Mail Ballot Status Data

This export file gives you the current status data for each mail ballot released for the selected election. It can be used by third-party mail balloting systems, to permit out sorting of returned ballots that have been referred to the Canvassing Board.

When you run the export, you will see a dialog where you can specify the delimiter of the file (tab, vertical bar, or comma), a file name, and location where the export file is to be placed.

Fields in the Export File

Field

Description

Election Number

Short integer, internal election number

Application ID

Bar code printed on return envelope

Return Batch Tray

Tray number in which returned mail ballot envelopes are stored

Sequence Inside Batch

Sequence number of ballot with the tray

Ballot Style

Ballot style (5 characters)

Absentee Ballot Number

Ballot number

FVRSVoterIDNumber

Voter registration ID

Date Mailed

Date ballot delivered (mailed, emailed, faxed, or collected)

Date Returned

Date mail ballot was return processed in Voter Focus

Date Image added to Voter Focus

Date the envelope image was added to the Voter Focus database

Date Image Processed by Voter Focus

Date the envelope image was processed and a disposition assigned to the ballot record

Absentee Rejection Reason

Whether the ballot was accepted or referred to the Canvassing Board. If there is no value in this field, the ballot was accepted. If the ballot was referred, one of the following referral reason codes will appear:

A    No address

B    PO Box address

L    Returned late

M    Voter moved to another county

N    No signature

P    Partial address

S    Signature different from file

X    MARG voter-No ID provided

Z    Returned undeliverable by postal service

ZZ  Temporarily away/forwarding address

Address Voter's full address, including city, state, and ZIP.
Name Voter's full name, including middle initial.